package com.empire.module.spider.dal.mysql.lotteryfootballgamezucaittg;

import java.util.*;

import com.empire.framework.common.pojo.PageResult;
import com.empire.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.empire.framework.mybatis.core.mapper.BaseMapperX;
import com.empire.module.spider.dal.dataobject.lotteryfootballgamezucaittg.LotteryFootballGameZucaiTtgDO;
import org.apache.ibatis.annotations.Mapper;
import com.empire.module.spider.controller.app.lotteryfootballgamezucaittg.vo.*;

/**
 * 足彩4场总进球游戏 Mapper
 *
 * @author 无敌
 */
@Mapper
public interface LotteryFootballGameZucaiTtgMapper extends BaseMapperX<LotteryFootballGameZucaiTtgDO> {

    default PageResult<LotteryFootballGameZucaiTtgDO> selectPage(AppLotteryFootballGameZucaiTtgPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<LotteryFootballGameZucaiTtgDO>()
                .eqIfPresent(LotteryFootballGameZucaiTtgDO::getGameNo, reqVO.getGameNo())
                .betweenIfPresent(LotteryFootballGameZucaiTtgDO::getStopTime, reqVO.getStopTime())
                .eqIfPresent(LotteryFootballGameZucaiTtgDO::getResult, reqVO.getResult())
                .eqIfPresent(LotteryFootballGameZucaiTtgDO::getExpect, reqVO.getExpect())
                .betweenIfPresent(LotteryFootballGameZucaiTtgDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(LotteryFootballGameZucaiTtgDO::getFid));
    }

}
